package org.suyisen.feng.core.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.suyisen.feng.core.domain.Cifuser;

/**
 * 
 */
@Mapper
public interface CifuserMapper {

	
	@Select("select * from cif_user")
	List<Cifuser> queryAllCifusers();
	
	@Insert("insert into cif_user(custid,custna,idtftp,idtfid,idvtop,idvted,birthd,sexytyp,addrcd,phone,address,createdate,createtime,modydt) VALUES(#{custid},#{custna},#{idtftp},#{idtfid},#{idvtop},#{idvted},#{birthd},#{sexytyp},#{addrcd},#{phone},#{address},#{createdate},#{createtime},#{modydt})")
	void createCifuser(Cifuser user);
	
	
	@Select("select * from cif_user where custid = #{custid} ")
	Cifuser queryOneCifusers(String custid);
	
	@Select("select * from cif_user limit 1 ")
	Cifuser queryTheOneCifusers();
}
